SET NOCOUNT ON
SET QUOTED_IDENTIFIER ON
GO

PRINT '---- SET DATATYPES'

UPDATE tblUFGDomains
SET udm_Datatype ='hyperlink'
WHERE udm_DomainName LIKE '%clb_URL%'

UPDATE tblUFGDomains
SET udm_Datatype ='email'
WHERE udm_DomainName LIKE '%clb_Email%'

UPDATE tblUFGDomains
SET udm_Datatype ='htmlmemo'
WHERE udm_DomainName LIKE '%clb_Description%'

UPDATE tblUFGDomains
SET udm_Datatype ='htmlmemo'
WHERE udm_DomainName LIKE '%mat_Description%'

UPDATE tblUFGDomains
SET udm_Datatype ='htmlmemo'
WHERE udm_DomainName LIKE '%cpx_Description%'

UPDATE tblUFGDomains
SET udm_Datatype ='htmlmemo'
WHERE udm_DomainName LIKE '%prs_Remarks%'

UPDATE tblUFGDomains
SET udm_Datatype ='rating'
WHERE udm_DomainName LIKE '%clb_Ranking%'

UPDATE tblUFGDomains
SET udm_Datatype ='date'
WHERE udm_DomainName LIKE '%prs_DateofBirth%'



update tblUFGDomains set udm_Datatype = 'date'
where udm_DomainName = 'LID^GEBOORTEDATUM'


PRINT '---- Verbergen contributionview'

UPDATE tblUFGTables SET utb_DisplayInCategory = 'UFGTABLES' WHERE utb_TableName = 'vwContributionCurrentSeason' 
UPDATE tblUFGTables SET utb_DisplayInCategory = 'UFGTABLES' WHERE utb_TableName = 'vwGrossContributionCurrentSeason' 


